exec xp_cmdshell 'dir e:\mssql\log'

select cast(p1.instance_name as varchar(15)) as [Database], p1.cntr_value as [Log Used], p2.cntr_value as [Log Size]
		from master.dbo.sysperfinfo p1
		inner join master.dbo.sysperfinfo p2
		on p1.instance_name = p2.instance_name
		where p1.counter_name = 'Log File(s) Used Size (KB)'
		and p2.counter_name = 'Log File(s) Size (KB)'
		and p1.instance_name <> '_Total'